create database Bank奉公如法 
go 

use Bnak
go

create table Info(
	Id int primary key identity(1,1) not null,
	Name varchar(20) not null,
	Sex varchar(20) not null,
	Age varchar(20) not null,
	Hobby varchar(20) not null,
	IsActive bit not null default 1,
	IsDelect bit not null default 0,
	CreateTime datetime not null default getdate(),
	UpdateTime datetime not null default getdate(),
	Remarks nvarchar(200) null
)

go
create table UsersInfo(
	Id int primary key identity(1,1) not null,
	UsersName varchar(20) not null,
	Password varchar(20) not null,
	IsActive bit not null default 0,
	IsDelect bit not null default 1,
	CreateTime datetime not null default getdate(),
	UpdateTime datetime not null default getdate(),
	Remarks nvarchar(200) null
)

insert into Info (Name,Sex,Age,Hobby,Remarks)values('托尼','男','20','喜欢玩机器啦','玩玩而已'),
('灭霸','女','25','喜欢偷钻石','就是喜欢啦'),
('敦煌','男','20','喜欢说屁话','就是话多了点')

insert into UsersInfo (UsersName,Password ,Remarks)values ('敦煌','555',''),('敦煌老弟','525','')
